| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumifs return #value
My sumifs function return #value. I tried in both ways:
=SUMIFS(D$5:D$40,A4:A40,A51,C$5:C$41,B51) =SUMIFS(D$5:D$40,A5:A41,"="&A52,C$5:C$41,"="&B52) It all returns #value. Could you please help? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use sumifs - | Excel Worksheet Functions | |||
| sumifs help | Excel Programming | |||
| Sumifs (I think) | Excel Worksheet Functions | |||
| SUMIFS | Excel Worksheet Functions | |||
| SUMIFS and OR | Excel Discussion (Misc queries) | |||
Threaded Mode
