Looking to added up based on a character from cell range

S

SudarCR

Hi,

I am looking for idea, how to add up cell range a1:a3 based on th
values in b1:b3 and c1:c3

A B C D
1 3 A S
=SUMIFS(A1:A2,B1:B2,"S",C1:C3,"<>A") =4
2 4 S Z
3 5 Z A,S Looking to formulate the abov
formula to arrive same answer.

In D3, I need to write the formula in such way it takes the character A
from C3 to calculate the sum.

In another word, how to find the character from cell rang
 
K

Kevin@Radstock

=SUMIFS(A1:A3,B1:B3,"A",C1:C3,"<>A")

SudarCR;1606661 said:
Hi,

I am looking for idea, how to add up cell range a1:a3 based on th
values in b1:b3 and c1:c3

A B C D
1 3 A S
=SUMIFS(A1:A2,B1:B2,"S",C1:C3,"<>A") =4
2 4 S Z
3 5 Z A,S Looking to formulate the abov
formula to arrive same answer.

In D3, I need to write the formula in such way it takes the character A
from C3 to calculate the sum.

In another word, how to find the character from cell rang
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
CONCATENATE cells if other cells are the same 3
Need help calculating probabilities 7
Protecting user from changing previous data 5
up and down array 7
Auto Fill Cell Based on Data in a different cell 4
Please suggest any formulae / functions 2

Top