Hi All,
there are 4 and 8 (the value in cells) but my sumfis can't extract hem
please see formula:
=SUMIFS(C6:C10,A6:A10,"="&A6,D6:D10," = "&E6 Suppose answer is 12
I also tried removing the ampersand but still 0. I have double checked all the values, are in general. Tried formatting as numbers too.
I can't make this formula work and there is no error . [TABLE="border: 1, cellpadding: 1, width: 500"]
A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][td]E
[/td][td]F
[/td][/tr][tr][td]39751
[/td][td]1245
[/td][td]4
[/td][td]5/18/18
[/td][td]5/18/18
[/td][td][/td][/tr][tr][td]39751
[/td][td]1245
[/td][td]8
[/td][td]5/18/18
[/td][td][/td][td][/td][/tr]
[/TABLE]
kindly assist