how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Who can help me with my issue?

I would like to summarize all fields in the coumn C that apply to given
'text' values in colums A AND B.

I tried VLOOKUP, but this is only applicable to the first value and limited
to two columns

SUMIF is more flexible but I cannot find the formula to first select the row
where both values in column A and B apply and only than the value in the
third column of the same row is added to the values in the next row with the
same match.
 
i have noticed u r in dubai. if u want advanced help in excel write to :
(e-mail address removed)
 
You must log in or register to reply here.

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

sumif from multiple columns 6
Scrabble Value calculation for Welsh words 0
Large Data File Consolidation... 2
addding/omitting "x" 5
If and Vlookup 3
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
With F1 value, look at A, if match or partial match return B 5
Concatenate If 4

Back
Top