We will be migrating from Ask to Discourse on the first week of August, read the details here

Sum if multiple criteria

Is there a way to construct a formula to produce a sum based on several criteria?

For example, I'd like to get a sum in L3 of column F where it's today's date (column A), and the symbol in column B = K3.

I tried several things with SUMIF, but it's beyond my meager abilities.

Many thanks in advance for any ideas.

DM

edit retag close merge delete

DougKMiles,

How the date intervene in the process? Do you want all values in F in L3 for today's date?

This formula will give F3 value:

=IF(B3=K3;F3)

If do you want a blank cell instead of zero when B3≠K3:

=IF(B3=K3;F3;"")

( 2020-05-29 20:26:35 +0200 )edit

Thanks Leroy! Yes, I'm trying to get all the values in F3 for today's date where the symbols in B column match K3. Also when I type in a semi-colon as you have in your formulas, it defaults to a comma on entry on my system. Any idea what's up with that?

( 2020-05-30 00:58:09 +0200 )edit

Sort by » oldest newest most voted

Something like as =SUMIFS(F2:F20;A2:A20;TODAY();B2:B20;K3)?

more

Thanks for the response John! That works!

Many thanks!

( 2020-05-30 01:17:55 +0200 )edit