nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

SUMIFS

toby45106

I keep getting an error when I try this formula. I basically want to Add Contract Amount if the YR = 18 and the MO <4.

Any suggestions?

Find more posts tagged with

Comments

Chris McKay

Hi Shirley,

Something like this perhaps:

=SUM(COLLECT([Contract Amount]:[Contract Amount], [Contract Date]:[Contract Date], YEAR(@cell) = 2018, [Contract Date]:[Contract Date], MONTH(@cell) < 4))

Kind regards,

Chris McKay

Sign in to join the conversation!

Quick Links

Trending discussions

The intermediary sheet not updating with the source
Hello, I have a destination sheet that is cell linked to a source sheet. The source sheet is constantly being updated (adding information, deleting information) but the destination sheet does not reflect those updates. Is there any work around this issue? Any way that the destination sheet reflects the updates real time? I…
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt
I am geting this erer
i got this error while working , when i close it it pops up again, i even restarted the app but no use. this happened last week to but it stoppedthe next day. can summon help . Update : it now stopped, after restarting it again and popping up again it stopped.What is triggering this error .