whatif / greater than formula

**mdarcey** · 05-18-2011, 04:08 PM

hi guys

would be greatfull if anyone can point out where i am going wrong with the formula below.

=SUMIFS(wholesale!D2:D26,wholesale!B2:B26,"Sealed Bid",wholesale!C2:C26,">2",wholesale!A2:A26,'sealed bid'!B2)

so i want the sum in sealed bid tab. the sum should be saying in the wholesale tab

- add the values in column D when
- column B says 'sealed bid'
- and then only if column C is greater than 2
- and then column A is equal to cell b2 in the sealed bid tab

The value comes back as 0 and no error. i think i have made an error with the >2 part if anyone can lend a hand

thanks once again
martin

**NBVC** · 05-18-2011, 04:17 PM

The formula is correct and is giving correct result. There are no items in Jan 2011, that have number of participants greater than 2.... so the result is 0.

If you put the formula in the next column to refer to February, you will see a number result.

Maybe you want >= 2 instead of just >2 ?

As in:

=SUMIFS(wholesale!$D$2:$D$26,wholesale!$B$2:$B$26,"Sealed Bid",wholesale!$C$2:$C$26,">=2",wholesale!$A$2:$A$26,'sealed bid'!B2)

copied across.

**TMS** · 05-18-2011, 04:21 PM

=SUMIFS(wholesale!$D$2:$D$26,wholesale!$B$2:$B$26,"Sealed Bid",wholesale!$C$2:$C$26,">2",wholesale!$A$2:$A$26,'sealed bid'!B$2)

and drag across.

You haven't made an error. There are no records that meet the date criteria for January.

Regards