Ask Your Question
0

Sum if multiple criteria

asked 2020-05-29 19:44:00 +0200

DougKMiles gravatar image

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.

image description

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

Many thanks in advance for any ideas.

DM

edit retag flag offensive close merge delete

Comments

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;"")

LeroyG gravatar imageLeroyG ( 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?

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

1 Answer

Sort by » oldest newest most voted
1

answered 2020-05-29 20:30:23 +0200

JohnSUN gravatar image

What about SUMIFS()?

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

edit flag offensive delete link more

Comments

Thanks for the response John! That works!

Many thanks!

DougKMiles gravatar imageDougKMiles ( 2020-05-30 01:17:55 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-29 19:44:00 +0200

Seen: 41 times

Last updated: May 29